import sqlite3
conn = sqlite3.connect('lujiuyu.db')
cursor = conn.cursor()
cursor.execute('create table user(id int(10) primary key,name varchar(20))')
cursor.close()
conn.close()

import sqlite3
conn = sqlite3.connect('lujiuyu.db')
cursor = conn.cursor()
cursor.execute('insert into user (id, name) values ("1","lujiuyu")')
cursor.execute('insert into user (id, name) values ("2","wangmengxue")')
cursor.execute('insert into user (id, name) values ("3","zhangwen")')
cursor.close()
conn.close()